SetRowValue

Note: This statement is named Set Recordset Row Value in the Add Statement dialog box.

Sets a field value in a recordset or data row.

This statement is also used by the CommitRecordsetRow statement.

Syntax

SetRowValue(Recordset/DataRow, "ColumnName", "Value")

Arguments

Argument Description
Recordset/DataRow Recordset or data row name. Must be opened with OpenRecordset or OpenRecordsetQuery.
ColumnName Column name to add the value to.
Value Value to set.

Example

bugs = OpenRecordset("WysiCorp Bugs")

lastName = SetRowValue(bugs, "Last Name", "Jones")